Programming Microsoft Visual Basic .NET/Programming Microsoft Visual Basic .NET (Microsoft Press)(X08-78517)(2002).bin/17 controls/databindingdemo/dsbiblio.vb

Text File | 2001-10-21 | 19.1 KB | 519 lines

'------------------------------------------------------------------------------
' <autogenerated>
'     This code was generated by a tool.
'     Runtime Version: 1.0.2914.16
'
'     Changes to this file may cause incorrect behavior and will be lost if
'     the code is regenerated.
' </autogenerated>
'------------------------------------------------------------------------------

Option Strict Off
Option Explicit On

Imports System
Imports System.Data
Imports System.Runtime.Serialization
Imports System.Xml


<Serializable(),  _
 System.ComponentModel.DesignerCategoryAttribute("code")>  _
Public Class dsBiblio
    Inherits System.Data.DataSet

    Private tablePublishers As PublishersDataTable

    Public Sub New()
        MyBase.New
        Me.InitClass
    End Sub

    Private Sub New(ByVal info As SerializationInfo, ByVal context As StreamingContext)
        MyBase.New
        Me.InitClass
        Me.GetSerializationData(info, context)
    End Sub

    <System.ComponentModel.Browsable(false),  _
     System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)>  _
    Public ReadOnly Property Publishers As PublishersDataTable
        Get
            Return Me.tablePublishers
        End Get
    End Property

    Protected Overrides Function ShouldSerializeTables() As Boolean
        Return false
    End Function

    Protected Overrides Function ShouldSerializeRelations() As Boolean
        Return false
    End Function

    Protected Overrides Sub ReadXmlSerializable(ByVal reader As XmlReader)
        Me.ReadXml(reader, XmlReadMode.IgnoreSchema)
    End Sub

    Protected Overrides Function GetSchemaSerializable() As System.Xml.Schema.XmlSchema
        Dim stream As System.IO.MemoryStream = New System.IO.MemoryStream
        Me.WriteXmlSchema(New XmlTextWriter(stream, Nothing))
        stream.Position = 0
        Return System.Xml.Schema.XmlSchema.Read(New XmlTextReader(stream), Nothing)
    End Function

    Private Sub InitClass()
        Me.DataSetName = "dsBiblio"
        Me.Namespace = "http://www.tempuri.org/dsBiblio.xsd"
        Me.tablePublishers = New PublishersDataTable
        Me.Tables.Add(Me.tablePublishers)
    End Sub

    Private Function ShouldSerializePublishers() As Boolean
        Return false
    End Function

    Public Delegate Sub PublishersRowChangeEventHandler(ByVal sender As Object, ByVal e As PublishersRowChangeEvent)

    Public Class PublishersDataTable
        Inherits DataTable
        Implements System.Collections.IEnumerable

        Private columnAddress As DataColumn

        Private columnCity As DataColumn

        Private columnComments As DataColumn

        Private columnCompany_Name As DataColumn

        Private columnFax As DataColumn

        Private columnName As DataColumn

        Private columnPubID As DataColumn

        Private columnState As DataColumn

        Private columnTelephone As DataColumn

        Private columnZip As DataColumn

        Friend Sub New()
            MyBase.New("Publishers")
            Me.InitClass
        End Sub

        <System.ComponentModel.Browsable(false)>  _
        Public ReadOnly Property Count As Integer
            Get
                Return Me.Rows.Count
            End Get
        End Property

        Friend ReadOnly Property AddressColumn As DataColumn
            Get
                Return Me.columnAddress
            End Get
        End Property

        Friend ReadOnly Property CityColumn As DataColumn
            Get
                Return Me.columnCity
            End Get
        End Property

        Friend ReadOnly Property CommentsColumn As DataColumn
            Get
                Return Me.columnComments
            End Get
        End Property

        Friend ReadOnly Property Company_NameColumn As DataColumn
            Get
                Return Me.columnCompany_Name
            End Get
        End Property

        Friend ReadOnly Property FaxColumn As DataColumn
            Get
                Return Me.columnFax
            End Get
        End Property

        Friend ReadOnly Property NameColumn As DataColumn
            Get
                Return Me.columnName
            End Get
        End Property

        Friend ReadOnly Property PubIDColumn As DataColumn
            Get
                Return Me.columnPubID
            End Get
        End Property

        Friend ReadOnly Property StateColumn As DataColumn
            Get
                Return Me.columnState
            End Get
        End Property

        Friend ReadOnly Property TelephoneColumn As DataColumn
            Get
                Return Me.columnTelephone
            End Get
        End Property

        Friend ReadOnly Property ZipColumn As DataColumn
            Get
                Return Me.columnZip
            End Get
        End Property

        Public Default ReadOnly Property Item(ByVal index As Integer) As PublishersRow
            Get
                Return CType(Me.Rows(index),PublishersRow)
            End Get
        End Property

        Public Event PublishersRowChanged As PublishersRowChangeEventHandler

        Public Event PublishersRowChanging As PublishersRowChangeEventHandler

        Public Event PublishersRowDeleted As PublishersRowChangeEventHandler

        Public Event PublishersRowDeleting As PublishersRowChangeEventHandler

        Public Overloads Sub AddPublishersRow(ByVal row As PublishersRow)
            Me.Rows.Add(row)
        End Sub

        Public Overloads Function AddPublishersRow(ByVal Address As String, ByVal City As String, ByVal Comments As String, ByVal Company_Name As String, ByVal Fax As String, ByVal Name As String, ByVal State As String, ByVal Telephone As String, ByVal Zip As String) As PublishersRow
            Dim rowPublishersRow As PublishersRow = CType(Me.NewRow,PublishersRow)
            rowPublishersRow.ItemArray = New Object() {Address, City, Comments, Company_Name, Fax, Name, Nothing, State, Telephone, Zip}
            Me.Rows.Add(rowPublishersRow)
            Return rowPublishersRow
        End Function

        Public Function FindByPubID(ByVal PubID As Integer) As PublishersRow
            Return CType(Me.Rows.Find(New Object() {PubID}),PublishersRow)
        End Function

        Public Function GetEnumerator() As System.Collections.IEnumerator Implements System.Collections.IEnumerable.GetEnumerator
            Return Me.Rows.GetEnumerator
        End Function

        Private Sub InitClass()
            Me.columnAddress = New DataColumn("Address", GetType(System.String), "", System.Data.MappingType.Element)
            Me.Columns.Add(Me.columnAddress)
            Me.columnCity = New DataColumn("City", GetType(System.String), "", System.Data.MappingType.Element)
            Me.Columns.Add(Me.columnCity)
            Me.columnComments = New DataColumn("Comments", GetType(System.String), "", System.Data.MappingType.Element)
            Me.Columns.Add(Me.columnComments)
            Me.columnCompany_Name = New DataColumn("Company Name", GetType(System.String), "", System.Data.MappingType.Element)
            Me.Columns.Add(Me.columnCompany_Name)
            Me.columnFax = New DataColumn("Fax", GetType(System.String), "", System.Data.MappingType.Element)
            Me.Columns.Add(Me.columnFax)
            Me.columnName = New DataColumn("Name", GetType(System.String), "", System.Data.MappingType.Element)
            Me.Columns.Add(Me.columnName)
            Me.columnPubID = New DataColumn("PubID", GetType(System.Int32), "", System.Data.MappingType.Element)
            Me.columnPubID.AutoIncrement = true
            Me.columnPubID.AllowDBNull = false
            Me.columnPubID.Unique = true
            Me.Columns.Add(Me.columnPubID)
            Me.columnState = New DataColumn("State", GetType(System.String), "", System.Data.MappingType.Element)
            Me.Columns.Add(Me.columnState)
            Me.columnTelephone = New DataColumn("Telephone", GetType(System.String), "", System.Data.MappingType.Element)
            Me.Columns.Add(Me.columnTelephone)
            Me.columnZip = New DataColumn("Zip", GetType(System.String), "", System.Data.MappingType.Element)
            Me.Columns.Add(Me.columnZip)
            Me.PrimaryKey = New DataColumn() {Me.columnPubID}
        End Sub

        Public Function NewPublishersRow() As PublishersRow
            Return CType(Me.NewRow,PublishersRow)
        End Function

        Protected Overrides Function NewRowFromBuilder(ByVal builder As DataRowBuilder) As DataRow
            'We need to ensure that all Rows in the tabled are typed rows.
            'Table calls newRow whenever it needs to create a row.
            'So the following conditions are covered by Row newRow(Record record)
            '* Cursor calls table.addRecord(record)
            '* table.addRow(object[] values) calls newRow(record)
            Return New PublishersRow(builder)
        End Function

        Protected Overrides Function GetRowType() As System.Type
            Return GetType(PublishersRow)
        End Function

        Protected Overrides Sub OnRowChanged(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowChanged(e)
            If (Not (Me.PublishersRowChangedEvent) Is Nothing) Then
                RaiseEvent PublishersRowChanged(Me, New PublishersRowChangeEvent(CType(e.Row,PublishersRow), e.Action))
            End If
        End Sub

        Protected Overrides Sub OnRowChanging(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowChanging(e)
            If (Not (Me.PublishersRowChangingEvent) Is Nothing) Then
                RaiseEvent PublishersRowChanging(Me, New PublishersRowChangeEvent(CType(e.Row,PublishersRow), e.Action))
            End If
        End Sub

        Protected Overrides Sub OnRowDeleted(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowDeleted(e)
            If (Not (Me.PublishersRowDeletedEvent) Is Nothing) Then
                RaiseEvent PublishersRowDeleted(Me, New PublishersRowChangeEvent(CType(e.Row,PublishersRow), e.Action))
            End If
        End Sub

        Protected Overrides Sub OnRowDeleting(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowDeleting(e)
            If (Not (Me.PublishersRowDeletingEvent) Is Nothing) Then
                RaiseEvent PublishersRowDeleting(Me, New PublishersRowChangeEvent(CType(e.Row,PublishersRow), e.Action))
            End If
        End Sub

        Public Sub RemovePublishersRow(ByVal row As PublishersRow)
            Me.Rows.Remove(row)
        End Sub
    End Class

    Public Class PublishersRow
        Inherits DataRow

        Private tablePublishers As PublishersDataTable

        Friend Sub New(ByVal rb As DataRowBuilder)
            MyBase.New(rb)
            Me.tablePublishers = CType(Me.Table,PublishersDataTable)
        End Sub

        Public Property Address As String
            Get
                Try
                    Return CType(Me(Me.tablePublishers.AddressColumn),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("Cannot get value because it is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePublishers.AddressColumn) = value
            End Set
        End Property

        Public Property City As String
            Get
                Try
                    Return CType(Me(Me.tablePublishers.CityColumn),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("Cannot get value because it is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePublishers.CityColumn) = value
            End Set
        End Property

        Public Property Comments As String
            Get
                Try
                    Return CType(Me(Me.tablePublishers.CommentsColumn),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("Cannot get value because it is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePublishers.CommentsColumn) = value
            End Set
        End Property

        Public Property Company_Name As String
            Get
                Try
                    Return CType(Me(Me.tablePublishers.Company_NameColumn),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("Cannot get value because it is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePublishers.Company_NameColumn) = value
            End Set
        End Property

        Public Property Fax As String
            Get
                Try
                    Return CType(Me(Me.tablePublishers.FaxColumn),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("Cannot get value because it is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePublishers.FaxColumn) = value
            End Set
        End Property

        Public Property Name As String
            Get
                Try
                    Return CType(Me(Me.tablePublishers.NameColumn),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("Cannot get value because it is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePublishers.NameColumn) = value
            End Set
        End Property

        Public Property PubID As Integer
            Get
                Return CType(Me(Me.tablePublishers.PubIDColumn),Integer)
            End Get
            Set
                Me(Me.tablePublishers.PubIDColumn) = value
            End Set
        End Property

        Public Property State As String
            Get
                Try
                    Return CType(Me(Me.tablePublishers.StateColumn),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("Cannot get value because it is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePublishers.StateColumn) = value
            End Set
        End Property

        Public Property Telephone As String
            Get
                Try
                    Return CType(Me(Me.tablePublishers.TelephoneColumn),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("Cannot get value because it is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePublishers.TelephoneColumn) = value
            End Set
        End Property

        Public Property Zip As String
            Get
                Try
                    Return CType(Me(Me.tablePublishers.ZipColumn),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("Cannot get value because it is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePublishers.ZipColumn) = value
            End Set
        End Property

        Public Function IsAddressNull() As Boolean
            Return Me.IsNull(Me.tablePublishers.AddressColumn)
        End Function

        Public Sub SetAddressNull()
            Me(Me.tablePublishers.AddressColumn) = System.Convert.DBNull
        End Sub

        Public Function IsCityNull() As Boolean
            Return Me.IsNull(Me.tablePublishers.CityColumn)
        End Function

        Public Sub SetCityNull()
            Me(Me.tablePublishers.CityColumn) = System.Convert.DBNull
        End Sub

        Public Function IsCommentsNull() As Boolean
            Return Me.IsNull(Me.tablePublishers.CommentsColumn)
        End Function

        Public Sub SetCommentsNull()
            Me(Me.tablePublishers.CommentsColumn) = System.Convert.DBNull
        End Sub

        Public Function IsCompany_NameNull() As Boolean
            Return Me.IsNull(Me.tablePublishers.Company_NameColumn)
        End Function

        Public Sub SetCompany_NameNull()
            Me(Me.tablePublishers.Company_NameColumn) = System.Convert.DBNull
        End Sub

        Public Function IsFaxNull() As Boolean
            Return Me.IsNull(Me.tablePublishers.FaxColumn)
        End Function

        Public Sub SetFaxNull()
            Me(Me.tablePublishers.FaxColumn) = System.Convert.DBNull
        End Sub

        Public Function IsNameNull() As Boolean
            Return Me.IsNull(Me.tablePublishers.NameColumn)
        End Function

        Public Sub SetNameNull()
            Me(Me.tablePublishers.NameColumn) = System.Convert.DBNull
        End Sub

        Public Function IsStateNull() As Boolean
            Return Me.IsNull(Me.tablePublishers.StateColumn)
        End Function

        Public Sub SetStateNull()
            Me(Me.tablePublishers.StateColumn) = System.Convert.DBNull
        End Sub

        Public Function IsTelephoneNull() As Boolean
            Return Me.IsNull(Me.tablePublishers.TelephoneColumn)
        End Function

        Public Sub SetTelephoneNull()
            Me(Me.tablePublishers.TelephoneColumn) = System.Convert.DBNull
        End Sub

        Public Function IsZipNull() As Boolean
            Return Me.IsNull(Me.tablePublishers.ZipColumn)
        End Function

        Public Sub SetZipNull()
            Me(Me.tablePublishers.ZipColumn) = System.Convert.DBNull
        End Sub
    End Class

    Public Class PublishersRowChangeEvent
        Inherits EventArgs

        Private eventRow As PublishersRow

        Private eventAction As System.Data.DataRowAction

        Public Sub New(ByVal row As PublishersRow, ByVal action As DataRowAction)
            MyBase.New
            Me.eventRow = row
            Me.eventAction = action
        End Sub

        Public ReadOnly Property Row As PublishersRow
            Get
                Return Me.eventRow
            End Get
        End Property

        Public ReadOnly Property Action As DataRowAction
            Get
                Return Me.eventAction
            End Get
        End Property
    End Class
End Class